Prerequisites

This topic describes the client prerequisites when replicating to a Google Cloud SQL for PostgreSQL target.

Qlik Replicate Server for Windows

• The PostgreSQL ODBC Driver: PostgreSQL ODBC Driver psqlodbc_13_01_0000-x64 or above must be installed on the Qlik Replicate machine.

• PgAdmin:

  1. Download and install pgAdmin 4 (Windows) on the Qlik Replicate machine.
  2. Add the "psql.exe" path to the system PATH.

• Microsoft Visual Studio 2013 Redistributable (x86) - not (x64) - must be installed on the Qlik Replicate machine.

Qlik Replicate Server for Linux

1. Download postgresql13-odbc-13.02.0000-1PGDG.rhel8.x86_64.rpm and install it on the Replicate machine.

2. Copy the driver location to the site_arep_login.sh file:

   echo "export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib:/usr/lib64:/usr/pgsql-13/lib" >> site_arep_login.sh

   This will add the driver to "LD_LIBRARY_PATH" and update the driver location in the site_arep_login.sh file.

3. Makes sure that the /etc/odbcinst.ini file contains an entry for PostgreSQL, as in the following example:

   [PostgreSQL]

   Description = PostgreSQL ODBC driver

   Driver = /usr/pgsql-13/lib/psqlodbc.so

   Setup = /usr/pgsql-13/lib/psqlodbcw.so

   Debug = 0

   CommLog = 1

   UsageCount = 2